Model Table SHOP ORDER OPERATION

Attributes

Attribute Description (where applicable)
SO Op Order NoBuilt as  ORDER_NO + ' - ' +  SEQUENCE_NO  + ' - ' + RELEASE_NO + ' - ' + OPERATION_NO
SO Operation Interruption CauseCause of operation interruption.
SO Operation MilestoneIs the operation defined as a milestone?
SO Operation Order NoCorresponding shop order number.
SO Operation Purch Order NoCorresponding purchase order number.
SO Operation ResourceResource identity.
SO Operation StatusStatus of Shop Order operation. I.e. Cancelled, Planned, Released etc

USED BY MODEL(S)

Model Name
Production Performance

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
SHOP ORDER OPERATIONFACT_SHOP_ORDER_OPERATION_TMFACT_SHOP_ORDER_OPERATION_BIFACT_SHOP_ORDER_OPERATIONData Mart